尝试从udl测试文件连接到SQL Server 2016时出现SSL安全错误 |
您所在的位置:网站首页 › sqlserver ssl安全错误 18 › 尝试从udl测试文件连接到SQL Server 2016时出现SSL安全错误 |
我正在尝试测试从本地PC(Win 7)到SQL Server 2016计算机(Win 2016 Standard X64)的SQL连接。我刚刚创建了一个虚拟的.udl文件,提供了服务器名称和SQL凭据,但我收到以下错误: 代码语言:javascript复制[DBNETLIB][ConnectionOpen (SecDoClientHandshake().]SSL Security error.如果我通过SQL Management Studio进行连接,则可以正常工作。 如果尝试使用ODBC工具测试数据源,则会在测试连接窗口中收到以下错误消息 代码语言:javascript复制Microsoft SQL Server Native Client Version 11.00.2100 Running connectivity tests... Attempting connection [Microsoft][SQL Server Native Client 11.0]Encryption not supported on the client. [Microsoft][SQL Server Native Client 11.0]SSL Provider: The client and server cannot communicate, because they do not possess a common algorithm. [Microsoft][SQL Server Native Client 11.0]Client unable to establish connection [Microsoft][SQL Server Native Client 11.0]A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online. TESTS FAILED!更新:对于.udl虚拟测试,我在SQL Server系统上启用了TLS1.0(注册表路径: HKLM SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols) |
今日新闻 |
点击排行 |
|
推荐新闻 |
图片新闻 |
|
专题文章 |
CopyRight 2018-2019 实验室设备网 版权所有 win10的实时保护怎么永久关闭 |